IF exists(SELECT * FROM dbo.sysobjects WHERE name='vulOudercontact' AND xtype='P') 
BEGIN
	DROP PROCEDURE vulOudercontact
END
GO

CREATE procedure vulOudercontact

as

insert into oudercontactLokalen(naamcode)
select l.naamcode from leraars as l
left join oudercontactLokalen as lo
on l.naamcode=lo.naamcode
where lo.naamcode is  null 